Formatting Columns

Report columns can be formatted by right-clicking on the column label and selecting from the following formatting options:-

  • Format: The options available will depend on the type of information shown in this column.
    • Text
    • Integer, Decimal, Money, Bigint, Float, Numeric, Smallint, Smallmoney, Tiniyint or Calculated fields can be formatted as:
      • Integer
      • Floating Point
      • Money
    • Date/Time fields can be formatted as:-
      • Short Date (/01/06/2016)
      • Long Date (Wednesday, January 1st, 2096)
      • Month (Jan)
      • Time (1:45:00 PM)
      • Short Date & Time (16/2/2054 1:15:00 AM)
      • 24 Hour Time (14:22)
  • Style
    • Normal
    • Bold
    • Italic/Bold
  • Align
    • Left
    • Right
    • Center
  • Text Colour
  • Background Colour
  • Width (pixels) - if no width is set, a column will expand or contract as best possible to fit within the available space
  • Maximum characters - this option can truncate a column if the text in it is too wide to fit

In the future, the following capabilities will also be implemented:-

  • Alert Colour 1
  • Alert Condition 1
  • Alert Colour 2
  • Alert Condition 2

Click the SAVE link to keep or settings, or CANCEL to forget them.

comments powered by Disqus